if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_InsertProduct]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_InsertProduct]
GO
CREATE PROC sp_InsertProduct
	@cateID		int,
	@proName	nvarchar(100),
	@image		varchar(200),
	@des		nvarchar(2000),
	@price		float
AS
BEGIN
	INSERT INTO Product
	(
		CategoryID, ProductName, Image, Description, Price
	)
	VALUES
	(
		@cateID, @proName, @image, @des, @price
	)
END